SORT ORDER BY
Short Description
The data is sorted for use in further stages of the query or to join to another data source.
Detailed Description​
By default, Oracle will not guarantee to deliver data in sorted order. Therefore if you need your result set sorted, you need to specify an ORDER BY
clause.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.